How to: Set a vertical page break on a worksheet.
Solution:
Select the column just right of where the vertical break is to be inserted and select 'Page Break' from the 'Insert' menu.
1) Select the column just right of where the vertical page break is to be inserted. (The entire column is highlighted.)
2) Select the 'Insert' menu and select 'Page Break'. (The worksheet is vertically split into separate pages at the break.)
NOTE: Manual page breaks are fixed and appear on the screen as dashed lines. Automatic page breaks automatically adjust when manual page breaks are inserted into a worksheet. Automatic page breaks appear as dotted lines.
